/*

 * Licensed to the Apache Software Foundation (ASF) under one

 * or more contributor license agreements.  See the NOTICE file

 * distributed with this work for additional information

 * regarding copyright ownership.  The ASF licenses this file

 * to you under the Apache License, Version 2.0 (the

 * "License"); you may not use this file except in compliance

 * with the License.  You may obtain a copy of the License at

 *

 *     http://www.apache.org/licenses/LICENSE-2.0

 *

 * Unless required by applicable law or agreed to in writing, software

 * distributed under the License is distributed on an "AS IS" BASIS,

 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

 * See the License for the specific language governing permissions and

 * limitations under the License.

 */

package com.bff.gaia.unified.sdk.transforms.xjoin.client.mysql.all;



import java.sql.Connection;

import java.sql.DriverManager;

import java.util.List;

import java.util.Map;

import com.bff.gaia.unified.sdk.schemas.Schema;

import com.bff.gaia.unified.sdk.transforms.xjoin.core.side.FieldInfo;

import com.bff.gaia.unified.sdk.transforms.xjoin.core.side.JoinInfo;

import com.bff.gaia.unified.sdk.transforms.xjoin.core.side.SideTableInfo;

import com.bff.gaia.unified.sdk.transforms.xjoin.core.utils.DtStringUtil;

import com.bff.gaia.unified.sdk.transforms.xjoin.client.rdb.all.RdbAllReqRow;

import com.bff.gaia.unified.vendor.guava.com.google.common.collect.Maps;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;



/**

 * Project Name: gaia-parent Description: Data: 2019/7/20 9:39

 *

 * @author tiger

 * @version v1.0

 */

public class MysqlAllReqRow extends RdbAllReqRow {



  private static final long serialVersionUID = 2098635140857937717L;



  private static final Logger LOG = LoggerFactory.getLogger(MysqlAllReqRow.class);



  private static final String MYSQL_DRIVER = "com.mysql.jdbc.Driver";



  private static final String MYSQL_DRIVER_6 = "com.mysql.cj.jdbc.Driver";



  public MysqlAllReqRow(

      Schema rowTypeInfo,

      JoinInfo joinInfo,

      List<FieldInfo> outFieldInfoList,

      SideTableInfo sideTableInfo) {

    super(rowTypeInfo, joinInfo, outFieldInfoList, sideTableInfo);

  }



  @Override

  public Connection getConn(String dbURL, String userName, String password) {

    try {

      Class.forName(MYSQL_DRIVER_6);

      // add param useCursorFetch=true

      Map<String, String> addParams = Maps.newHashMap();

      addParams.put("useCursorFetch", "true");

      String targetDbUrl = DtStringUtil.addJdbcParam(dbURL, addParams, true);

      return DriverManager.getConnection(targetDbUrl, userName, password);

    } catch (Exception e) {

      LOG.error("", e);

      throw new RuntimeException("", e);

    }

  }



  @Override

  public int getFetchSize() {

    return Integer.MIN_VALUE;

  }

}